<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>

<html>
<head>
    <title>后台登录</title>
    <meta name="renderer" content="webkit|ie-comp|ie-stand">
    <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
    <meta name="viewport"
          content="width=device-width,user-scalable=yes, minimum-scale=0.4, initial-scale=0.8,target-densitydpi=low-dpi"/>
    <%--<meta http-equiv="Cache-Control" content="no-siteapp" />--%>

    <jsp:include page="head.jsp"></jsp:include>

    <style type="text/css">
        .layui-table {
            text-align: center;
        }

        .layui-table th {
            text-align: center;
        }
    </style>
</head>

<body>
<div class="x-nav">
      <span class="layui-breadcrumb">
        <a href="">首页</a>
        <a href="${pageContext.request.contextPath}/findDormitory">宿舍信息</a>

      </span>
    <a class="layui-btn layui-btn-small" style="line-height:1.6em;margin-top:3px;float:right"
       href="${pageContext.request.contextPath}/findDormitory"
       title="刷新">
        <i class="layui-icon" style="line-height:30px">ဂ</i></a>
</div>
<div class="x-body">
    <div class="layui-row">
        <form class="layui-form layui-col-md12 x-so" action="${pageContext.request.contextPath}/findDormitory">
            <input class="layui-input" placeholder="请输入宿舍编号" name="s_dormitoryid" id="s_dormitoryid">
            <input class="layui-input" placeholder="请输入宿舍楼" name="d_dormbuilding" id="d_dormbuilding">
            <input class="layui-input" placeholder="请输入管理员姓名" name="a_name" id="a_name">

            <input class="layui-input" type="hidden" name="pageIndex" value="1">
            <input class="layui-input" type="hidden" name="pageSize" value="3">
            <button class="layui-btn" lay-submit="" lay-filter="sreach"><i class="layui-icon">&#xe615;</i></button>
        </form>
    </div>
    <xblock>
        <button id="addStudnetBtn" class="layui-btn layui-btn-normal"><i class="layui-icon">&#xe654;</i>添加</button>
        <button class="layui-btn layui-btn-warm" lay-filter="toolbarDemo" lay-submit=""><i
                class="layui-icon">&#xe67c;</i>导出
        </button>
        <span class="x-right" style="line-height:40px">共有数据：${di.totalCount} 条</span>
    </xblock>

    <%--添加模态框--%>
    <div class="layui-row" id="test" style="display: none;">
        <div class="layui-col-md10">
            <form class="layui-form" id="addEmployeeForm">
                <div class="layui-form-item">
                    <label class="layui-form-label">宿舍编号：</label>
                    <div class="layui-input-block">
                        <input type="text" name="s_dormitoryid" class="layui-input" placeholder="请输入宿舍编号">
                    </div>
                </div>

                <div class="layui-form-item">
                    <label class="layui-form-label">宿舍楼：</label>
                    <div class="layui-input-block">
                        <select name="d_dormbuilding" lay-verify="required">
                            <option value=""></option>
                            <option value="23号楼">23号楼</option>
                            <option value="24号楼">24号楼</option>
                            <option value="25号楼">25号楼</option>
                            <option value="26号楼">26号楼</option>
                            <option value="27号楼">27号楼</option>
                        </select>
                    </div>
                </div>

                <div class="layui-form-item">
                    <label class="layui-form-label">床位总数：</label>
                    <div class="layui-input-block">
                        <input type="text" name="d_bedtotal" class="layui-input" placeholder="请输入床位总数">
                    </div>
                </div>

                <div class="layui-form-item">
                    <label class="layui-form-label">已用床位：</label>
                    <div class="layui-input-block">
                        <input type="text" name="d_bed" class="layui-input" placeholder="请输入已用床位">
                    </div>
                </div>

                <div class="layui-form-item">
                    <label class="layui-form-label">管理员：</label>
                    <div class="layui-input-block">
                        <select name="a_name" lay-verify="required">
                            <option value=""></option>
                            <option value="焦颖">焦颖</option>
                            <option value="周荀凯">周荀凯</option>
                            <option value="张杰">张杰</option>
                            <option value="王皓">王皓</option>
                            <option value="张伟">张伟</option>
                            <option value="杨雯雯">杨雯雯</option>
                            <option value="王凡">王凡</option>
                            <option value="张娜">张娜</option>
                            <option value="蒋子华">蒋子华</option>
                            <option value="薛磊">薛磊</option>
                        </select>
                    </div>
                </div>

                <div class="layui-form-item">
                    <div class="layui-input-block">
                        <button type="button" class="layui-btn layui-btn-normal" lay-submit lay-filter="formDemo">提交
                        </button>
                        <button type="reset" class="layui-btn layui-btn-primary">重置</button>
                    </div>
                </div>
            </form>
        </div>
    </div>


    <%--表格数据--%>
    <table class="layui-table">
        <thead>
        <tr>
            <th>序号</th>
            <th>宿舍编号</th>
            <th>宿舍楼</th>
            <th>床位总数</th>
            <th>已用床位</th>
            <th>管理员</th>
            <th>操作</th>
        </thead>
        <tbody>
        <c:forEach items="${di.list}" var="di" varStatus="s">
            <tr>
                    <%--<td>--%>
                    <%--<div class="layui-unselect layui-form-checkbox" lay-skin="primary" data-id='2'><i class="layui-icon">&#xe605;</i></div>--%>
                    <%--</td>--%>
                <td>${s.count}</td>
                <td>${di.s_dormitoryid}</td>
                <td>${di.d_dormbuilding}</td>
                <td>${di.d_bedtotal}</td>
                <td>${di.d_bed}</td>
                <td>${di.a_name}</td>
                <td>
                    <a title="编辑" id="updateEdit"
                       href="${pageContext.request.contextPath}/findDormitoryById?d_id=${di.d_id}">
                        <i class="layui-icon">&#xe642;</i>
                    </a>
                    <a title="删除" onclick="member_del(this,'${di.d_id}')" href="javascript:;">
                        <i class="layui-icon">&#xe640;</i>
                    </a>
                </td>
            </tr>
        </c:forEach>
        </tbody>
    </table>

    <div class="">
        <input type="hidden" id="totalPageCount" value="${di.pageTotalCount}"/>
        <c:import url="pageBtn.jsp">
            <c:param name="totalCount" value="${di.totalCount}"/>
            <c:param name="currentPageNo" value="${di.pageIndex}"/>
            <c:param name="totalPageCount" value="${di.pageTotalCount}"/>
        </c:import>
    </div>
    <script>

        layui.config({
            base: 'layui_exts/',
        }).extend({
            excel: 'excel',
        });

        layui.use(['jquery', 'excel', 'form', 'layer', 'laydate'], function () {
            var form = layui.form,
                $ = layui.jquery,
                laydate = layui.laydate;
            var excel = parent.layui.excel;

            //执行一个laydate实例
            laydate.render({
                elem: '#start' //指定元素
            });

            form.on('submit(toolbarDemo)', function () {

                $.ajax({
                    url: '${pageContext.request.contextPath}/exportdormitorylist',
                    type: 'post',
                    dataType: 'json',
                    contentType: "application/json; charset=utf-8",
                    success: function (data) {
                        console.log(data);

                        // 1. 如果需要调整顺序，请执行梳理函数
                        var dt = excel.filterExportData(data, [
                            'd_id'
                            , 's_dormitoryid'
                            , 'd_dormbuilding'
                            , 'd_bedtotal'
                            , 'd_bed'
                            , 'a_name'
                        ]);

                        // 2. 数组头部新增表头
                        dt.unshift({
                            d_id: 'ID',
                            s_dormitoryid: '宿舍编号',
                            d_dormbuilding: '宿舍楼',
                            d_bedtotal: '床位总数',
                            d_bed: '医用床位',
                            a_name: '管理员'
                        });

                        // 意思是：A列40px，B列60px(默认)，C列120px，D、E、F等均未定义
                        var colConf = excel.makeColConfig({
                            'C': 90,
                            'F': 80
                        }, 60);

                        var timestart = Date.now();
                        // 3. 执行导出函数，系统会弹出弹框
                        excel.exportExcel({
                            sheet1: dt
                        }, '宿舍数据.xlsx', 'xlsx', {
                            extend: {
                                '!cols': colConf
                            }
                        });
                        var timeend = Date.now();

                        var spent = (timeend - timestart) / 1000;
                        layer.alert('导出耗时 ' + spent + ' s');
                        //setTimeout(function () {window.location.href='/findAdmin';},2000);
                    },

                    error: function () {
                        //console.log(data);
                        setTimeout(function () {
                            window.location.href = '${pageContext.request.contextPath}/findDormitory';
                        }, 2000);
                    }
                });
            });

            /*添加弹出框*/
            $("#addStudnetBtn").click(function () {
                layer.open({
                    type: 1,
                    title: "添加宿舍",
                    skin: "myclass",
                    area: ["50%"],
                    anim: 2,
                    content: $("#test").html()
                });
                $("#addEmployeeForm")[0].reset();
                form.on('submit(formDemo)', function (data) {
                    // layer.msg('aaa',{icon:1,time:3000});
                    var param = data.field;
                    // console.log(JSON.stringify(param));
                    $.ajax({
                        url: '${pageContext.request.contextPath}/addDormitory',
                        type: "post",
                        data: JSON.stringify(param),
                        contentType: "application/json; charset=utf-8",
                        success: function () {
                            layer.msg('添加成功', {icon: 1, time: 3000});
                            setTimeout(function () {
                                window.location.href = '${pageContext.request.contextPath}/findDormitory';
                            }, 2000);

                        },
                        error: function () {
                            layer.msg('添加失败', {icon: 0, time: 3000});
                            setTimeout(function () {
                                window.location.href = '${pageContext.request.contextPath}/findDormitory';
                            }, 2000);
                        }
                    });
                    // return false;
                });
            });

        });


        /*删除*/
        function member_del(obj, d_id) {
            layer.confirm('确认要删除吗？', function (index) {
                //发异步删除数据
                $.get("${pageContext.request.contextPath}/deleteDormitory", {"d_id": d_id}, function (data) {
                    if (data = true) {
                        layer.msg('删除成功!', {icon: 1, time: 2000});
                        setTimeout(function () {
                            window.location.href = '${pageContext.request.contextPath}/findDormitory';
                        }, 2000);

                    } else {
                        layer.msg('删除失败!', {icon: 1, time: 2000});
                        setTimeout(function () {
                            window.location.href = '${pageContext.request.contextPath}/findDormitory';
                        }, 2000);
                    }
                });
            });
        }

    </script>

</body>


</html>
